﻿<template>
	<div class="sysDbLink-container">
		<el-card shadow="hover"
			:body-style="{ padding: '20px 20px 16px 10px', display: 'flex', width: '100%', height: '100%', alignItems: 'start' }">
			<el-form :model="state.queryParams" ref="queryForm" :show-message="false" :inlineMessage="true" label-width="auto"
				style="flex: 1 1 0%" @submit.prevent="handleQuery">
				<el-row :gutter="10">
					<el-col :xs="24" :sm="12" :md="8" :lg="6" :xl="6" class="mb5">
						<el-form-item label="关键字" prop="searchKey">
							<el-input v-model="state.queryParams.searchKey" placeholder="请输入模糊查询关键字" clearable
								@keyup.enter.native="handleQuery" />
						</el-form-item>
					</el-col>
					<el-col :xs="24" :sm="12" :md="8" :lg="6" :xl="6" class="mb5" v-if="state.showAdvanceQueryUI">
						<el-form-item label="连接名称" prop="name">
							<el-input v-model="state.queryParams.name" placeholder="连接名称" clearable
								@keyup.enter.native="handleQuery" />
						</el-form-item>
					</el-col>
					<el-col :xs="24" :sm="12" :md="8" :lg="6" :xl="6" class="mb5" v-if="state.showAdvanceQueryUI">
						<el-form-item label="连接驱动" prop="dBType">
							<el-input v-model="state.queryParams.dBType" placeholder="连接驱动" clearable
								@keyup.enter.native="handleQuery" />
						</el-form-item>
					</el-col>
					<el-col :xs="24" :sm="12" :md="8" :lg="6" :xl="6" class="mb5" v-if="state.showAdvanceQueryUI">
						<el-form-item label="主机地址" prop="host">
							<el-input v-model="state.queryParams.host" placeholder="主机地址" clearable
								@keyup.enter.native="handleQuery" />
						</el-form-item>
					</el-col>
					<el-col :xs="24" :sm="12" :md="8" :lg="6" :xl="6" class="mb5" v-if="state.showAdvanceQueryUI">
						<el-form-item label="端口">
							<el-input-number v-model="state.queryParams.port" placeholder="请输入端口" clearable
								@keyup.enter.native="handleQuery" />
						</el-form-item>
					</el-col>
					<el-col :xs="24" :sm="12" :md="8" :lg="6" :xl="6" class="mb5" v-if="state.showAdvanceQueryUI">
						<el-form-item label="备注" prop="remark">
							<el-input v-model="state.queryParams.remark" placeholder="备注" clearable
								@keyup.enter.native="handleQuery" />
						</el-form-item>
					</el-col>

				</el-row>
			</el-form>
			<el-divider style="height: calc(100% - 5px); margin: 0 10px" direction="vertical" />
			<el-row>
				<el-col>
					<el-button-group>
						<el-button type="primary" icon="ele-Search" @click="handleQuery" :loading="options.loading"> 查询 </el-button>
						<el-button icon="ele-Refresh" @click="resetQuery" :loading="options.loading"> 重置 </el-button>
						<el-button icon="ele-ZoomIn" @click="changeAdvanceQueryUI" v-if="!state.showAdvanceQueryUI"
							style="margin-left: 5px"> 高级查询 </el-button>
						<el-button icon="ele-ZoomOut" @click="changeAdvanceQueryUI" v-if="state.showAdvanceQueryUI"
							style="margin-left: 5px"> 隐藏 </el-button>
					</el-button-group>
				</el-col>
			</el-row>
		</el-card>
		<el-card class="full-table" shadow="hover" style="margin-top: 5px">
			<vxe-grid ref="xGrid" class="xGrid-style" v-bind="options" v-on="gridEvents">
				<template #toolbar_buttons>
					<el-button type="primary" icon="ele-Plus" @click="handleAdd"> 新增 </el-button>
				</template>
				<template #toolbar_tools> </template>
				<template #empty>
					<el-empty :image-size="200" />
				</template>
				<template #row_record="{ row }">
					<ModifyRecord :data="row" />
				</template>
				<template #row_buttons="{ row }">
					<el-tooltip content="编辑" placement="top">
						<el-button icon="ele-Edit" size="small" text type="primary" @click="handleEdit(row)" />
					</el-tooltip>
					<el-tooltip content="删除" placement="top">
						<el-button icon="ele-Delete" size="small" text type="danger" @click="handleDelete(row)" />
					</el-tooltip>
				</template>
			</vxe-grid>
		</el-card>

		<PrintDialog ref="printDialogRef" :title="state.title" @reloadTable="handleQuery" />
		<EditDialog ref="editDialogRef" :title="state.title" @reloadTable="handleQuery" />
	</div>
</template>

<script lang="ts" setup name="sysDbLink">
import { onMounted, reactive, ref } from 'vue';
import { ElMessageBox, ElMessage } from "element-plus";
import { auth } from '/@/utils/authFunction';

import { VxeGridInstance, VxeGridListeners, VxeGridPropTypes } from 'vxe-table';
import { useVxeTable } from '/@/hooks/useVxeTableOptionsHook';
import { Local } from '/@/utils/storage';

import { formatDate } from '/@/utils/formatTime';

// 子窗口
import PrintDialog from '/@/views/system/print/component/hiprint/preview.vue';
import EditDialog from '/@/views/system/dbLink/component/editDialog.vue';
import ModifyRecord from '/@/components/table/modifyRecord.vue';

import { getAPI } from '/@/utils/axios-utils';
// import { SysDbLinkApi } from '/@/api-services/api';
// import { SysDbLink, SysDbLinkInput, SysDbLinkOutput } from '/@/api-services/models';
import { pageSysDbLink, deleteSysDbLink } from '/@/api/system/sysDbLink';

// 子窗口对象
const xGrid = ref<VxeGridInstance>();
const printDialogRef = ref<InstanceType<typeof PrintDialog>>();
const editDialogRef = ref<InstanceType<typeof EditDialog>>();

// 变量
const state = reactive({
	showAdvanceQueryUI: false,
	queryParams: {
		searchKey: undefined,
		name: undefined,
		dBType: undefined,
		host: undefined,
		port: undefined,
		userName: undefined,
		password: undefined,
		serviceName: undefined,
		remark: undefined,
		dBSchema: undefined,
		tableSpace: undefined,
		oracleParam: undefined,
		oracleExtend: undefined,
	},
	localPageParam: {
		pageSize: 50 as number,
		defaultSort: { field: 'createTime', order: 'asc', descStr: 'desc' },
	},
	visible: false,
	title: '',
});

// 本地存储参数
const localPageParamKey = 'localPageParam:sysDbLink';

// 改变高级查询的控件显示状态
const changeAdvanceQueryUI = () => {
	state.showAdvanceQueryUI = !state.showAdvanceQueryUI;
};

// 表格参数配置
const options = useVxeTable<SysDbLink>(
	{
		id: 'SysDbLink',
		name: '数据连接',
		columns: [
			{ type: 'seq', title: '序号', width: 60, fixed: 'left' },
			{ field: 'name', title: '连接名称', minWidth: 100, showOverflow: 'tooltip', sortable: false },
			{ field: 'dbType', title: '连接驱动', minWidth: 100, showOverflow: 'tooltip', sortable: false },
			{ field: 'host', title: '主机地址', minWidth: 100, showOverflow: 'tooltip', sortable: false },
			{ field: 'port', title: '端口', minWidth: 100, showOverflow: 'tooltip', sortable: false },
			{ title: '修改记录', width: 100, showOverflow: 'tooltip', slots: { default: 'row_record' } },
			{ title: '操作', fixed: 'right', width: 180, showOverflow: true, slots: { default: 'row_buttons' } },
		],
	},
	// vxeGrid配置参数(此处可覆写任何参数)，参考vxe-table官方文档
	{
		// 代理配置
		proxyConfig: { autoLoad: true, ajax: { query: ({ page, sort }) => handleQueryApi(page, sort) } },
		// 排序配置
		sortConfig: { defaultSort: Local.get(localPageParamKey)?.defaultSort || state.localPageParam.defaultSort },
		// 分页配置
		pagerConfig: { pageSize: Local.get(localPageParamKey)?.pageSize || state.localPageParam.pageSize },
		// 工具栏配置
		toolbarConfig: { export: false },
		// 行设置
		// rowConfig: { height: 80 },
	}
);

// 页面初始化
onMounted(async () => {
	await handleQuery();
});

// 查询api
const handleQueryApi = async (page: VxeGridPropTypes.ProxyAjaxQueryPageParams, sort: VxeGridPropTypes.ProxyAjaxQuerySortCheckedParams) => {
	const params = Object.assign(state.queryParams, { page: page.currentPage, pageSize: page.pageSize, field: sort.field, order: sort.order, descStr: 'desc' }) as SysDbLinkInput;
	return pageSysDbLink(params);
};

// 查询操作
const handleQuery = async (reset = false) => {
	options.loading = true;
	await xGrid.value?.commitProxy('query');
	options.loading = false;
};

// 重置操作
const resetQuery = async () => {
	state.queryParams.searchKey = undefined,
		state.queryParams.name = undefined,
		state.queryParams.dBType = undefined,
		state.queryParams.host = undefined,
		state.queryParams.port = undefined,
		state.queryParams.userName = undefined,
		state.queryParams.password = undefined,
		state.queryParams.serviceName = undefined,
		state.queryParams.remark = undefined,
		state.queryParams.dBSchema = undefined,
		state.queryParams.tableSpace = undefined,
		state.queryParams.oracleParam = undefined,
		state.queryParams.oracleExtend = undefined,
		await xGrid.value?.commitProxy('reload');
};

// 打开新增页面
const handleAdd = () => {
	state.title = '添加数据连接';
	editDialogRef.value?.openDialog({ type: 1 });
};

// 打开编辑页面
const handleEdit = (row: any) => {
	state.title = '编辑数据连接';
	editDialogRef.value?.openDialog(row);
};

// 打开打印页面
const handlePrint = async (row: any) => {
	state.title = '打印数据连接';
};

// 删除
const handleDelete = (row: any) => {
	ElMessageBox.confirm(`确定删除数据连接：【${row.title}】?`, '提示', {
		confirmButtonText: '确定',
		cancelButtonText: '取消',
		type: 'warning',
	}).then(async () => {
		await deleteSysDbLink(row);
		await handleQuery();
		ElMessage.success('删除成功');
	})
		.catch(() => { });
};

// 表格事件
const gridEvents: VxeGridListeners<SysDbLink> = {
	// 只对 pager-config 配置时有效，分页发生改变时会触发该事件
	async pageChange({ pageSize }) {
		state.localPageParam.pageSize = pageSize;
		Local.set(localPageParamKey, state.localPageParam);
	},
	// 当排序条件发生变化时会触发该事件
	async sortChange({ field, order }) {
		state.localPageParam.defaultSort = { field: field, order: order!, descStr: 'desc' };
		Local.set(localPageParamKey, state.localPageParam);
	},
};

</script>

<style lang="scss" scoped>
:deep(.el-input),
:deep(.el-select),
:deep(.el-input-number) {
	width: 100%;
}
</style>
